Person vStateProvinceCountryRegion (view)

Modified on 2011/08/27 11:17 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''View'''
| Person.vStateProvinceCountryRegion
|- valign="top"
| '''Description'''
| Joins StateProvince table with CountryRegion table.
|}

=== Source ===
{{{{<nowiki>
CREATE VIEW [Person].[vStateProvinceCountryRegion] 
WITH SCHEMABINDING 
AS 
SELECT 
    sp.[StateProvinceID] 
    ,sp.[StateProvinceCode] 
    ,sp.[IsOnlyStateProvinceFlag] 
    ,sp.[Name] AS [StateProvinceName] 
    ,sp.[TerritoryID] 
    ,cr.[CountryRegionCode] 
    ,cr.[Name] AS [CountryRegionName]
FROM [Person].[StateProvince] sp 
    INNER JOIN [Person].[CountryRegion] cr 
    ON sp.[CountryRegionCode] = cr.[CountryRegionCode];
</nowiki>}}}}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Select
| Table
| [[Person CountryRegion (table)|Person.CountryRegion]]

|- valign="top"
| Select
| Table
| [[Person StateProvince (table)|Person.StateProvince]]

|- valign="top"
| Schema
| Schema
| [[Person (schema)|Person]]

|}

devio dbscript ScrewTurn Wiki

Navigation¶

Person vStateProvinceCountryRegion (view)